package com.kgw.gatewaybluetooth.db;

import android.provider.BaseColumns;

/**
 * Created by jaydenma on 16/6/28.
 */
public class StudentTable {

    public static final String table = "t_student";

    public final class StudentColums implements BaseColumns {
        public final static String CHILDREN_NAME = "ChildrenName";
        public final static String PARENT_PATH = "ParentPath";
        public final static String CLASS_NAME = "classname";
        public final static String SCHOOL_NAME = "SchoolName";
        public final static String IMAGEPATH = "ImagePath";
        public final static String CHILDREN_ID = "ChildrenId";
        public final static String ID = "Id";
        public final static String CARD_NO = "cardNo";
        public final static String NAME = "NAME";
        public final static String TEACHERID = "teacherId";
    }


    public static String getCreateTableSQL() {
        StringBuilder sb = new StringBuilder();
        sb.append("CREATE TABLE IF NOT EXISTS " + table + "(");
        sb.append(StudentColums.CHILDREN_ID + " VARCHAR(50),");
        sb.append(StudentColums.CHILDREN_NAME + " VARCHAR(50),");
        sb.append(StudentColums.PARENT_PATH + " VARCHAR(50),");
        sb.append(StudentColums.CLASS_NAME + " VARCHAR(50),");
        sb.append(StudentColums.SCHOOL_NAME + " VARCHAR(50),");
        sb.append(StudentColums.IMAGEPATH + " VARCHAR(50),");
        sb.append(StudentColums.ID + " VARCHAR(50),");
        sb.append(StudentColums.CARD_NO + " VARCHAR(50),");
        sb.append(StudentColums.NAME + " VARCHAR(50),");
        sb.append(StudentColums.TEACHERID + " VARCHAR(50)");
        sb.append(");");
//        LogUtil.d(DefaultConsts.TAG, table + ":" + sb.toString());
        return sb.toString();
    }
}
